SELECT  
A.NF_SAIDA,
A.SERIE_NF,
B.CODIGO_ITEM,
B.DESCRICAO_ITEM,
B.QTDE_ITEM,
B.DESCONTO_ITEM,
B.VALOR_ITEM
FROM faturamento A
JOIN FATURAMENTO_ITEM B ON (A.FILIAL = B.FILIAL  AND A.NF_SAIDA = B.NF_SAIDA AND A.SERIE_NF = B.SERIE_NF)
where A.NF_SAIDA in ('286401','286402','286403')
ORDER BY A.NF_SAIDA,B.CODIGO_ITEM